﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="phones.aspx.vb" Inherits="admin_phones" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <title>SmartTaxi управление - база номеров

    </title>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div class="row">

        <h3 style="border-bottom: 1px solid #c6c6c6">База номеров</h3>

        <div class="row" style="padding-left:35px; padding-right:35px;">
       
            <div class="col-sm-12">



                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="100" Width="355px">
                    <Columns>
                        <asp:BoundField DataField="user_name" HeaderText="Имя пользователя" ReadOnly="True" SortExpression="user_name" />
                        <asp:BoundField DataField="user_phone" HeaderText="Номер телефона" ReadOnly="True" SortExpression="user_phone" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:1gb_smarttaxiConnectionString %>" SelectCommand="SELECT taxt_firstname + ' ' + taxi_lastname AS user_name, taxi_phone AS user_phone FROM taxist UNION (SELECT 'Клиент' AS user_name, order_user_phone AS user_phone FROM orders WHERE (order_user_phone &lt;&gt; '') GROUP BY order_user_phone) ORDER BY user_name"></asp:SqlDataSource>



            </div>
        </div>
    </div>
</asp:Content>

